﻿CREATE TABLE [dbo].[ProsuseInPunctLucru] (
    [IDProdus]     INT NOT NULL,
    [IDClient]     INT NOT NULL,
    [IDPunctLucru] INT NULL,
    CONSTRAINT [FK_ProsuseInPunctLucru_Produse] FOREIGN KEY ([IDProdus]) REFERENCES [dbo].[Produse] ([IDProdus]),
    CONSTRAINT [FK_ProsuseInPunctLucru_PunctLucru] FOREIGN KEY ([IDPunctLucru]) REFERENCES [dbo].[PunctLucru] ([IDPunctLucru]),
    CONSTRAINT [IX_ProsuseInPunctLucru] UNIQUE NONCLUSTERED ([IDProdus] ASC, [IDClient] ASC, [IDPunctLucru] ASC)
);

